Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RAWTOHEX

Syntax

Description of the illustration rawtohex.gif

Purpose

`RAWTOHEX` converts `raw` to a character value containing its hexadecimal equivalent. The `raw` argument must be `RAW` datatype.

You can specify a `BLOB` argument for this function if it is called from within a PL/SQL block.

Examples

The following hypothetical example returns the hexadecimal equivalent of a `RAW` column value:

    SELECT RAWTOHEX(raw_column) "Graphics"
       FROM graphics;

    Graphics
    --------
    7D

See Also: "RAW and LONG RAW Datatypes" and HEXTORAW